﻿CREATE PROCEDURE [dbo].[proc_Employee_WageSeries_CompanyId_GetList]
	(
		@WSId uniqueidentifier
	)
AS
	Select 
		wsc.Id,
		wsc.WSId,
		wsc.CompanyId,
		(Select C.CompanyName From Company C Where C.Id=wsc.CompanyId) as CompanyName 
	From Employee_WageSeries_Company wsc Where wsc.WSId=@WSId
	RETURN
